/* create datasets for regressions */
libname edu '!userprofile\\Dropbox\Education\Replication\Data';

* add data from industry_skew_major, add suffix _major to all variables;
data skew1;
  set edu.industry_skew_major_bio;
run;

proc sql;
select cat(name, ' = ', cats(name, '_major' )) into :renstr separated by ' ' from
dictionary.columns where libname = 'WORK' and memname='SKEW1';
quit;

data skew2;
set skew1 (rename = (&renstr));
rename year_major = year;
rename major_major = major;
run; 

* save as permanent datasets;
data edu.skew_bio; set skew2; run;
proc sort data = edu.skew_bio; by year major; run;


